CREATE procedure [dbo].[BAEChangeLogGetByType] @LogType as varchar(10), @UserID as
varchar(32)
AS
IF @LogType = '1' --Shows only the past 6 months of records
    BEGIN
        SELECT Name_Log.DATE_TIME AS 'Date/Time',
        Name_Log.USER_ID AS 'User',
        Name_Log.LOG_TEXT AS 'Log'         
        
        FROM Name_Log
        WHERE Name_Log.ID = @UserID
        AND DATE_TIME >= dateadd(month,-6,getdate())
        ORDER BY DATE_TIME DESC, USER_ID
    END
ELSE --Shows all records if no selection is passed in
    BEGIN
        SELECT Name_Log.DATE_TIME AS 'Date/Time',
        Name_Log.USER_ID AS 'User',
        Name_Log.LOG_TEXT AS 'Log'         
        
        FROM Name_Log
        WHERE Name_Log.ID = @UserID
        ORDER BY DATE_TIME DESC, USER_ID
    END



set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON

GO